DEV Community: Rasma Raj

Find number of lines of code in a .Net project

Rasma Raj — Fri, 04 Mar 2022 07:00:17 +0000

I had a requirement to find the number of lines in a major project which has been completed with .Net 2019.

The way I found the number of lines of coding is -

Step 1: Open the project
step 2: View > Other Windows > Code Metrics Results

step 3 :

Download multiple files in zipped format

Rasma Raj — Tue, 15 Feb 2022 07:09:55 +0000

Use System.IO.Compression class for compressing the file in .Zip format

=> Create a instance of the MemoryStream .
=> Create Zipped folder in memory
=> Use archive.CreateEntry method to add files into the zip folder
=> Add content into the created files
=> Now the zipped folder with all files stored in the memory instance
=> Then return the file , the save As file dialogue appears in the window.

using System.IO.Compression;

public void DownloadFilesInZip()
{
 var _ListOfFiles=new List<Tuple<int,byte[],string>>()
{
new Tuple<int,byte[],string>(1,F1,FileName1),
new Tuple<int,byte[],string>(2,F2,FileName2),
new Tuple<int,byte[],string>(3,F3,FileName3)
};

using (MemoryStream ms = new MemoryStream())
{
using (var archive = new ZipArchive(ms, ZipArchiveMode.Create, true))
     {
     foreach (var _file in _ListOfFiles)
        {
     var entry = archive.CreateEntry(_file.Item3, CompressionLevel.Fastest);

     using (var zipStream = entry.Open())
         {
zipStream.Write(_file .Item2, 0, _file .Item2.Length);
         }

        }
    }
string _FileName = $"DateTime.Now.ToString("ddMMyyyy")}.zip";
return File(ms.ToArray(), "application/zip", _FileName);
                    }

}

HttpPostedFileBase

Rasma Raj — Wed, 09 Feb 2022 07:02:38 +0000

My requirement was to send the file through the mail and save the file in binary format.

Issue faced
File content length became 0 after converted to the byte array.

Solution

1) Created a class with properties

public class Model_File
    {
        public string FileName { get;private set; }
        public string ContentType { get; private set; }
        public byte[] Contents { get; private set; }
        public Model_File(string FileName, string ContentType, byte[] Contents)
        {
            this.FileName = FileName;
            this.ContentType = ContentType;
            this.Contents = Contents;
        }
    }

2) Read all the file using binary reader and store in a List of class

public static List<Model_File> Get_File(HttpPostedFileBase[] postedfiles)
{

var Result =new List<Model.Model_File>();
if (postedfiles.Length != 0)
            {
                foreach (var item in postedfiles)
                {
                    if (item.ContentLength != 0)
                    {
                        var R = Try_Byte(item, "Attachment");                       
                        if (R != null)
                        {
                            Result .Add(R);                            
                        }
                    }

                }
            }
return Result;
}

private static Model_File Try_Byte(HttpPostedFileBase F,string CType)
        {
            Model.Model_File Result = null;
            if (F != null && F.ContentLength!=0)
            {
                using (BinaryReader dr = new BinaryReader(F.InputStream))
                {
                    byte[] content = dr.ReadBytes(F.ContentLength);
                    return new Model_File(F.FileName, CType, content);
                }
            }
            return Result;
        }

3) To Send these files in mail - Create the attachment and add to the mail message

public static void Send(List<Model_File> _Files)
{
MailMessage msg = new MailMessage()

if(_Files.count!=0)
{
_Files.foreach(delegate(Model_File F){

var _Attachment=Get(F)
if(_Attachment!=mull){
msg.Attachments.Add(_Attachment);
}

});
}
}

private static Attachment Get(Model_File F)
        {
            if (F != null && F.Contents!=null && F.Contents.Length!=0 && !string.IsNullOrWhiteSpace(F.ContentType))
            {
               return new Attachment(new MemoryStream(F.Contents), F.FName);
            }
            return null;
        }

4) Get the result- List of Model_Files objects and inserted to the database in varbinary format.For that I created the column in table with an attribute varbinary(max).

*Issue *
Cant covert to varbinary to varchar - this error got when added like a normal parameter.

Solution
Then i declared the parameter as below.

Command.Parameters.Add("@Attachment", System.Data.SqlDbType.VarBinary, -1).Value = (A.Contents == null ? (object)DBNull.Value : (object)A.Contents );