/* This event is used to Import all suggestion in the form of CSV format*/
protected void btnUpload_Click(object sender, EventArgs e)
{
string BreedName, StrPet, StrStatus;
int PetType;
int Status;
string Error = string.Empty;
StoreFront ObjStoreFront = new StoreFront();
DataSet ds = new DataSet();
string strExtension;
strExtension = Path.GetExtension(flUpload.Value);
if (strExtension == ".CSV" || strExtension == ".csv")
{
string fileName;
string line;
string fileDir;
StreamReader sr;
fileDir = Server.MapPath("../StoreData/");
fileName = fileDir + "/" + Convert.ToString(DateTime.Now.Ticks) + ".txt";
flUpload.PostedFile.SaveAs(fileName);
sr = File.OpenText(fileName);
int recordCount = 0;
while (sr.Peek() != -1)
{
line = sr.ReadLine();
string[] recordArray;
char[] splitter = { ',' };
recordArray = line.Split(splitter);
if (recordArray[0].Replace(",", "") == "BreedName")
{
continue;
}
else
{
if (recordArray.Length == 3)
{
BreedName = (recordArray[0].Trim().Replace('#', ','));
StrStatus = recordArray[1].Trim().Replace('#', ',');
if (StrStatus == "Active")
{
Status = 1;
}
else if (StrStatus == "Inactive")
{
Status = 0;
}
else
{
Status = 1;
}
StrPet = (recordArray[2].Trim().Replace('#', ',').ToLower());
if (StrPet == "cat")
{
PetType = 0;
}
else
{
PetType = 1;
}
int Dup = ObjStoreFront.AddBreedExcel(BreedName, PetType, Status);
if (Dup == 0)
{
if (Error == "")
{
Error = "Duplicate Breed name - " + BreedName;
}
else
{
Error = Error + ", " + BreedName;
}
}
recordCount++;
}
else
{
Error = "coloumn count does not match";
}
}
}
if (Error == "")
{
SuccesfullMessage("Record Added successfully.");
}
else
{
ErrMessage(Error);
}
}
else
{
ErrMessage("Sorry, File Format Not Supported. You can upload files in .csv format only.");
}
BindGrid(PetTypeID);
}